Add records to one table from another table
1) Select the 'Query' menu and select 'Append...'. (The Append dialog box appears.)
2) In the 'Table Name' box in the 'Append To' group, enter the name of the table to which to append the fields in the design grid.
3) Do one of the following:
a) If the table to which to append the data is in the open database, select the 'Current Database' radio button.
b) If the table to which to append the data is in a different database:
1] Select the 'Another Database' radio button.
2] Enter the path and filename of the other database in the 'File Name' box.
4) Choose 'OK'.
5) Add fields that are to be appended to another table to the query design grid:
a) To add all the fields in one table in the Query Design window:
1] Select the asterisk (*) in the desired table field list in the top half of the Query Design window.
2] Drag the asterisk (*) to the design grid in the bottom half of the Query Design window. (All the fields for that table are included in the append.)
b) Select the desired field from a table field list in the top half of the Query Design window.
c) Drag the field to the desired column of the design grid in the bottom half of the Query Design window.
d) Release the mouse button. (The field name appears in the Field row, and its table appears in the Table row.)
e) Repeat steps 5)a) through 5)d) for each field to append to another table.
NOTE: Fields can also be added by selecting a field from the drop-down list box in the 'Field' row of the design grid in the bottom half of the Query Design window.
6) (Special Case) If the fields to be appended and the fields in the table to append to have different names:
a) Enter the names of each corresponding field in the table appending to in the 'Append To' row.
b) Repeat step 6)a) for each field in the query design grid with a different name than in the append table being created.